Providing Better Support for Quanti ed Queries
نویسندگان
چکیده
Relational database systems do not e ectively support complex queries containing quanti ers (quanti ed queries) that are increasingly becoming important in decision support applications. Generalized quanti ers provide an e ective way of expressing such queries naturally. In this paper, we consider the problem of processing quanti ed queries within the generalized quanti er framework. We demonstrate that current relational systems are ill-equipped, both at the language and at the query processing level, to deal with such queries. We also provide insights into the intrinsic di culties associated with processing such queries. We then describe the implementation of a quanti ed query processor, QP, that is based on multidimensional and boolean matrix structures. We provide results of performance experiments run on QP that demonstrate superior performance on quanti ed queries. Our results indicate that it is feasible to augment relational systems with query subsystems like QP for signi cant performance bene ts for quanti ed queries in decision support applications.
منابع مشابه
Providing Better Support for Quanti
Relational database systems do not eeectively support complex queries containing quantiiers (quantiied queries) that are increasingly becoming important in decision support applications. Generalized quantiiers provide an eeective way of expressing such queries naturally. In this paper, we consider the problem of processing quantiied queries within the generalized quantiier framework. We demonst...
متن کاملUnnesting and Optimization Techniques for Extended-sql Queries Containing Generalized Quantiiers
Relational database systems do not eeectively support complex queries containing quantiiers (quanti-ed queries). Quantiied queries are becoming increasingly important in decision support applications in general, and health-care information systems in particular. Recently, it has been shown that generalized quantiiers provide an eeective way of expressing such queries naturally, and that general...
متن کاملDeveloping a BIM-based Spatial Ontology for Semantic Querying of 3D Property Information
With the growing dominance of complex and multi-level urban structures, current cadastral systems, which are often developed based on 2D representations, are not capable of providing unambiguous spatial information about urban properties. Therefore, the concept of 3D cadastre is proposed to support 3D digital representation of land and properties and facilitate the communication of legal owners...
متن کاملGeneralized Quanti ers
We considered the problem of processing queries that contain generalized quanti ers. We demonstrate that current relational systems are ill-equipped, both at the language and at the query processing level, to deal with such queries. We propose a boolean matrix approach which establishes the feasibility of building systems that can process queries with generalized quanti ers e ciently, and we pr...
متن کاملProving Implications by Algebraic Approximation
This paper applies techniques of algebraic approximation to provide e ective algorithms to determine the validity of universally quanti ed implications over lattice structures. We generalize the known result which states that any semilattice is approximated in the two element lattice. We show that the validity of a universally quanti ed implication over a possibly in nite domain can be determin...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1999